MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Nationality = 199

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Medium, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
71885 C.I.45.61.6a–q 0 0 86584 Costume Institute 8 Riding Habit 6100 Riding habit French 7         Department Store|Department Store|Department Store|Department Store 248 (a, b)|(d)|(e)|(i) Busvines & Co. Paris|Franklin Simon & Co.|Belle Jardinière, Paris|E. Motsch French|American, founded 1902|French|French   Busvines & Co. Paris|Franklin Simon & Co.|Belle Jardinière, Paris|E. Motsch 6009 French|American|French|French 199 1902 9999 1928 1928 1928 (a-c) wool (d) linen (e-h) cotton (i) wool (j, k) leather (l-q) wood 16508   Gift of Mrs. Frank Farley, 1945                           Metropolitan Museum of Art, New York, NY 1
93262 2009.300.906a–f 0 0 159488 Costume Institute 8 Evening suit 5883 Evening suit French 7         Designer|Manufacturer|Designer|Design House 305 (f)|(d)|(a, b)|(a, b) E. Larue|Cluett, Peabody & Company, Inc.|Jeanne Lanvin|House of Lanvin French|American, founded 1898|French, 1867–1946|French, founded 1889   Larue E.|Cluett, Peabody & Company, Inc.|Lanvin, Jeanne|Lanvin, House of 7450 French|American|French|French 199 1898 |1867 |1889 9999 |1946 |9999 1927 1927 1927 wool, cotton, silk 16483   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Albert Moss, 1967                           Metropolitan Museum of Art, New York, NY 1
217664 54.90.964 0 0 345159 Drawings and Prints 11 Print 731 Vue Générale de New York, prise à vol d'oiseu           Lithographer|Artist|Publisher|Printer 1657   Léon-Auguste Asselineau|John Bachmann|Wild|Lemercier French, Hamburg 1808–1889 Rouen|American (born Germany or Switzerland), active New York 1849–85|Paris|Paris   Asselineau, Léon-Auguste|Bachmann, John|Wild|Lemercier 21374 French|American|French|French 199 1808 |1849 |1800 |1800 1889 |1885 |1900 |1899 ca. 1850 1845 1855 Hand-colored lithograph with gum arabic additions 34107 image: 16 5/8 x 23 11/16 in. (42.3 x 60.2 cm) sheet: 20 3/8 x 26 3/8 in. (51.8 x 67 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
259247 54.90.1352 0 0 387946 Drawings and Prints 11 Print 731 Falls of Niagara, Three Miles Off; Western Canal near the Little Falls of the Mohawk; New York From the East River; Little Falls of the Mohawk           Artist|Publisher|Publisher|Lithographer 4490   Jacques Gérard Milbert|Bailly and Ward|Rosselin|Benard French, Paris 1766–1840 Paris|New York, NY|Paris|French, active ca. 1830   Milbert, Jacques Gérard|Bailly and Ward|Rosselin|Benard 37448 French|American|French|French 199 1766 |1800 |1800 |1800 1840 |1850 |1850 |1850 ca. 1830 1825 1835 Lithograph 14948 image: 7 3/16 x 10 5/8 in. (18.2 x 27 cm) sheet: 12 1/8 x 18 1/2 in. (30.8 x 47 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
292204 67.630.36 0 1 421536 Drawings and Prints 11 Print 731 Broad-Way, New York         "Views of American Cities," pl. 44 1030 Printer|Artist|Lithographer|Publisher 4739 After Cattier|Augustus Köllner|Isidore-Laurent Deroy|Goupil & Co. Paris|American, born Wurttenburg, Germany 1812|French, 1797–1886   Cattier|Kollner, Augustus|Deroy, Isidore-Laurent|Goupil & Co. 41832 French|American|French|French 199 1800 |1812 |1797 |1850 1900 |1912 |1886 |1950 1850 1850 1850 Lithograph 14948 Image: 8 1/16 × 11 3/4 in. (20.4 × 29.8 cm) Sheet: 13 9/16 × 18 7/16 in. (34.4 × 46.8 cm) Bequest of Susan Dwight Bliss, 1966                       Prints 13   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 126.08ms · Data license: CC0 · Data source: metmuseum/openaccess